data homogenization processing summary and QC check results

files processed:

type	filename
provided data	Copy of hf007-02-litterfallJM.csv
provided data	Copy of hf007-07-root-mass.csv
provided data	Copy of hf007-08-soil-prop-1990.csv
provided data	Copy of hf007-09-soil-prop-1991.csv
provided data	Copy of hf007-10-soil-prop-1995.csv
provided data	Copy of hf007-11-soil-prop-2000.csv
homogenized data	Copy of hf007-02-litterfallJM_HMGZD
homogenized data	Copy of hf007-07-root-mass_HMGZD
homogenized data	Copy of hf007-08-soil-prop-1990_HMGZD
homogenized data	Copy of hf007-09-soil-prop-1991_HMGZD
homogenized data	Copy of hf007-10-soil-prop-1995_HMGZD
homogenized data	Copy of hf007-11-soil-prop-2000_HMGZD

summary of row counts from submitted and homogenized data:

data_entity	num_rows_data	num_rows_homogenized
Copy of hf007-02-litterfallJM.csv	21	21
Copy of hf007-11-soil-prop-2000.csv	117	117
Copy of hf007-10-soil-prop-1995.csv	99	99
Copy of hf007-09-soil-prop-1991.csv	63	63
Copy of hf007-07-root-mass.csv	21	21
Copy of hf007-08-soil-prop-1990.csv	19	19

confirm all location-level variables entered into the key file were included in the homogenized data

data_source	data_check
Copy of hf007-11-soil-prop-2000_HMGZD	all provided location variables included
Copy of hf007-10-soil-prop-1995_HMGZD	all provided location variables included
Copy of hf007-09-soil-prop-1991_HMGZD	all provided location variables included
Copy of hf007-08-soil-prop-1990_HMGZD	all provided location variables included
Copy of hf007-07-root-mass_HMGZD	all provided location variables included
Copy of hf007-02-litterfallJM_HMGZD	all provided location variables included

confirm all profile-level variables entered into the key file were included in the homogenized data

profile data variables expected: 25
profile data variables homogenized: 54

data_source	providedName	homogenizedName	exampleValue
Copy of hf007-11-soil-prop-2000_HMGZD	plot	L2	21
Copy of hf007-11-soil-prop-2000_HMGZD	rep	L3	C
Copy of hf007-11-soil-prop-2000_HMGZD	treatment	tx_L1	TOX
Copy of hf007-11-soil-prop-2000_HMGZD	date	observation_date_1	11109
Copy of hf007-11-soil-prop-2000_HMGZD	avg.per.c	soc	46.08
Copy of hf007-11-soil-prop-2000_HMGZD	avg.per.n	n_tot	2.1
Copy of hf007-11-soil-prop-2000_HMGZD	depth top	layer_top	0
Copy of hf007-11-soil-prop-2000_HMGZD	depth bottom	layer_bot	10
Copy of hf007-10-soil-prop-1995_HMGZD	plot	L2	21
Copy of hf007-10-soil-prop-1995_HMGZD	rep	L3	C
Copy of hf007-10-soil-prop-1995_HMGZD	treatment	tx_L1	TOX
Copy of hf007-10-soil-prop-1995_HMGZD	date	observation_date_1	9131
Copy of hf007-10-soil-prop-1995_HMGZD	avg.per.c	soc	0.45
Copy of hf007-10-soil-prop-1995_HMGZD	soil.c	soc_stock	7719
Copy of hf007-10-soil-prop-1995_HMGZD	avg.per.n	n_tot	0.02
Copy of hf007-10-soil-prop-1995_HMGZD	c.n	c_to_n	29.29
Copy of hf007-10-soil-prop-1995_HMGZD	depth top	layer_top	0
Copy of hf007-10-soil-prop-1995_HMGZD	depth bottom	layer_bot	10
Copy of hf007-10-soil-prop-1995_HMGZD	db.0to10	bd_samp	1.49
Copy of hf007-10-soil-prop-1995_HMGZD	ph	ph_h2o	4.57
Copy of hf007-10-soil-prop-1995_HMGZD	exch.ca	ca	11.4
Copy of hf007-10-soil-prop-1995_HMGZD	exch.mg	mg	3.13
Copy of hf007-10-soil-prop-1995_HMGZD	exch.k	k	2.03
Copy of hf007-10-soil-prop-1995_HMGZD	exch.na	na	0.35
Copy of hf007-10-soil-prop-1995_HMGZD	exch.al	al	14.88
Copy of hf007-10-soil-prop-1995_HMGZD	exch.bases	base_sum	15.16
Copy of hf007-10-soil-prop-1995_HMGZD	cec	cec_sum	18.58
Copy of hf007-10-soil-prop-1995_HMGZD	base.sat	bs	1.21
Copy of hf007-09-soil-prop-1991_HMGZD	plot	L2	21
Copy of hf007-09-soil-prop-1991_HMGZD	rep	L3	-Inf
Copy of hf007-09-soil-prop-1991_HMGZD	treatment	tx_L1	TOX
Copy of hf007-09-soil-prop-1991_HMGZD	date	observation_date_1	7974
Copy of hf007-09-soil-prop-1991_HMGZD	avg.per.c	soc	47.2
Copy of hf007-09-soil-prop-1991_HMGZD	avg.per.n	n_tot	2.12
Copy of hf007-09-soil-prop-1991_HMGZD	avg.d.13c	15n	-25.3
Copy of hf007-09-soil-prop-1991_HMGZD	avg.d.15n	13c	6.9
Copy of hf007-09-soil-prop-1991_HMGZD	depth top	layer_top	10
Copy of hf007-09-soil-prop-1991_HMGZD	depth bottom	layer_bot	15
Copy of hf007-09-soil-prop-1991_HMGZD	ph	ph_h2o	4.47
Copy of hf007-08-soil-prop-1990_HMGZD	plot	L2	21
Copy of hf007-08-soil-prop-1990_HMGZD	date	observation_date_1	7578
Copy of hf007-08-soil-prop-1990_HMGZD	avg.per.c	soc	48.24
Copy of hf007-08-soil-prop-1990_HMGZD	avg.per.n	n_tot	2.07
Copy of hf007-08-soil-prop-1990_HMGZD	depth top	layer_top	0
Copy of hf007-08-soil-prop-1990_HMGZD	depth bottom	layer_bot	15
Copy of hf007-07-root-mass_HMGZD	block	L1	3
Copy of hf007-07-root-mass_HMGZD	plot	L2	21
Copy of hf007-07-root-mass_HMGZD	treatment	tx_L1	O/A-less
Copy of hf007-07-root-mass_HMGZD	fine10.avg	bgb	1489
Copy of hf007-02-litterfallJM_HMGZD	block	L1	3
Copy of hf007-02-litterfallJM_HMGZD	plot	L2	21
Copy of hf007-02-litterfallJM_HMGZD	treatment	tx_L1	O/A-less
Copy of hf007-02-litterfallJM_HMGZD	date	observation_date_1	12015
Copy of hf007-02-litterfallJM_HMGZD	abv litter 2002	litterfall_anpp	7118

summary plotting

## $`Copy of hf007-11-soil-prop-2000_HMGZD`
## $`Copy of hf007-11-soil-prop-2000_HMGZD`[[1]]

## 
## $`Copy of hf007-11-soil-prop-2000_HMGZD`[[2]]

## 
## $`Copy of hf007-11-soil-prop-2000_HMGZD`[[3]]

## 
## $`Copy of hf007-11-soil-prop-2000_HMGZD`[[4]]

## 
## $`Copy of hf007-11-soil-prop-2000_HMGZD`[[5]]

## 
## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[1]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[2]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[3]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[4]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[5]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[6]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[7]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[8]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[9]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[10]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[11]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[12]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[13]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[14]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[15]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[16]]

## 
## $`Copy of hf007-10-soil-prop-1995_HMGZD`[[17]]

## 
## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[1]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[2]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[3]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[4]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[5]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[6]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[7]]

## 
## $`Copy of hf007-09-soil-prop-1991_HMGZD`[[8]]

## 
## 
## $`Copy of hf007-08-soil-prop-1990_HMGZD`
## $`Copy of hf007-08-soil-prop-1990_HMGZD`[[1]]

## 
## $`Copy of hf007-08-soil-prop-1990_HMGZD`[[2]]

## 
## $`Copy of hf007-08-soil-prop-1990_HMGZD`[[3]]

## 
## $`Copy of hf007-08-soil-prop-1990_HMGZD`[[4]]

## 
## $`Copy of hf007-08-soil-prop-1990_HMGZD`[[5]]

## 
## 
## $`Copy of hf007-07-root-mass_HMGZD`
## $`Copy of hf007-07-root-mass_HMGZD`[[1]]

## 
## 
## $`Copy of hf007-02-litterfallJM_HMGZD`
## $`Copy of hf007-02-litterfallJM_HMGZD`[[1]]

## 
## $`Copy of hf007-02-litterfallJM_HMGZD`[[2]]